package org.zh.sh.entity;

public class AppUser {
    /**
     * 用户所关联的角色分隔符,-->varchar-->varchar(100)-->-->     */
    public static final String appRoles = "appRoles";
    /**
     * 用户邮箱号-->varchar-->varchar(30)-->UNI-->     */
    public static final String appUserEmail = "appUserEmail";
    /**
     * 用户性别-->set-->set('男','女')-->-->     */
    public static final String appUserGender = "appUserGender";
    /**
     * ID-->int-->int unsigned-->PRI-->auto_increment     */
    public static final String appUserId = "appUserId";
    /**
     * 用户其他信息所组合的json数据-->json-->json-->-->     */
    public static final String appUserJson = "appUserJson";
    /**
     * 用户昵称-->varchar-->varchar(20)-->-->     */
    public static final String appUserName = "appUserName";
    /**
     * 用户的登录密码-->varchar-->varchar(15)-->-->     */
    public static final String appUserPassword = "appUserPassword";
    /**
     * 用户电话-->varchar-->varchar(11)-->UNI-->     */
    public static final String appUserTel = "appUserTel";

    public static final String tableName = "app_user";
    public static final String queryById = "select * from app_user where appUserId = ?";
    public static final String deleteById = "delete from app_user where appUserId = ?";
    public static final String updateAll = "update app_user set appRoles= ? ,appUserEmail= ? ,appUserGender= ? ,appUserJson= ? ,appUserName= ? ,appUserPassword= ? ,appUserTel= ? where appUserId = ?";
}